show index from xchan;
+-------+------------+--------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table | Non_unique | Key_name           | Seq_in_index | Column_name        | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+-------+------------+--------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| xchan |          0 | PRIMARY            |            1 | xchan_hash         | A         |      133592 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_guid         |            1 | xchan_guid         | A         |      133592 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_addr         |            1 | xchan_addr         | A         |      133592 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_name         |            1 | xchan_name         | A         |      133592 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_network      |            1 | xchan_network      | A         |         435 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_url          |            1 | xchan_url          | A         |      133592 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_flags        |            1 | xchan_flags        | A         |           2 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_connurl      |            1 | xchan_connurl      | A         |       66796 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_instance_url |            1 | xchan_instance_url | A         |           2 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_follow       |            1 | xchan_follow       | A         |        7031 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_hidden       |            1 | xchan_hidden       | A         |         114 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_orphan       |            1 | xchan_orphan       | A         |           2 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_censored     |            1 | xchan_censored     | A         |           2 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_selfcensored |            1 | xchan_selfcensored | A         |         120 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_system       |            1 | xchan_system       | A         |         116 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_pubforum     |            1 | xchan_pubforum     | A         |         118 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_deleted      |            1 | xchan_deleted      | A         |         218 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xchan |          1 | xchan_photo_m      |            1 | xchan_photo_m      | A         |      133592 |     NULL | NULL   |      | BTREE      |         |               | NO      |
+-------+------------+--------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+

show index from hubloc;
+--------+------------+--------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table  | Non_unique | Key_name           | Seq_in_index | Column_name        | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+--------+------------+--------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| hubloc |          0 | PRIMARY            |            1 | hubloc_id          | A         |      264303 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_url         |            1 | hubloc_url         | A         |       88101 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_guid        |            1 | hubloc_guid        | A         |      264303 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_hash        |            1 | hubloc_hash        | A         |      264303 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_flags       |            1 | hubloc_flags       | A         |           6 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_connect     |            1 | hubloc_connect     | A         |           2 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_host        |            1 | hubloc_host        | A         |       88101 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_addr        |            1 | hubloc_addr        | A         |      264303 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_updated     |            1 | hubloc_updated     | A         |      264303 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_connected   |            1 | hubloc_connected   | A         |      264303 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_status      |            1 | hubloc_status      | A         |           8 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_network     |            1 | hubloc_network     | A         |          10 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_primary     |            1 | hubloc_primary     | A         |           2 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_orphancheck |            1 | hubloc_orphancheck | A         |           2 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_deleted     |            1 | hubloc_deleted     | A         |           4 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_error       |            1 | hubloc_error       | A         |           2 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_id_url      |            1 | hubloc_id_url      | A         |      264303 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| hubloc |          1 | hubloc_site_id     |            1 | hubloc_site_id     | A         |        1785 |     NULL | NULL   |      | BTREE      |         |               | NO      |
+--------+------------+--------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+

show index from xprof;
+-------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table | Non_unique | Key_name       | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+-------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| xprof |          0 | PRIMARY        |            1 | xprof_hash     | A         |       23025 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xprof |          1 | xprof_desc     |            1 | xprof_desc     | A         |       11512 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xprof |          1 | xprof_dob      |            1 | xprof_dob      | A         |        7675 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xprof |          1 | xprof_gender   |            1 | xprof_gender   | A         |         479 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xprof |          1 | xprof_marital  |            1 | xprof_marital  | A         |        1046 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xprof |          1 | xprof_sexual   |            1 | xprof_sexual   | A         |         130 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xprof |          1 | xprof_locale   |            1 | xprof_locale   | A         |         575 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xprof |          1 | xprof_region   |            1 | xprof_region   | A         |        2878 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xprof |          1 | xprof_postcode |            1 | xprof_postcode | A         |        1151 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xprof |          1 | xprof_country  |            1 | xprof_country  | A         |        2558 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xprof |          1 | xprof_age      |            1 | xprof_age      | A         |         128 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| xprof |          1 | xprof_hometown |            1 | xprof_hometown | A         |        2558 |     NULL | NULL   |      | BTREE      |         |               | NO      |
+-------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+